Overview
Brought to you by YData
Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 21721 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 14.8 MiB |
| Average record size in memory | 712.9 B |
Variable types
| Categorical | 5 |
|---|---|
| Text | 4 |
| DateTime | 1 |
| Numeric | 9 |
Category has constant value "22KT" | Constant |
Gwt(Grams) is highly overall correlated with Purchase Value and 4 other fields | High correlation |
Profit Margin % is highly overall correlated with Purchase Value | High correlation |
Purchase Value is highly overall correlated with Gwt(Grams) and 5 other fields | High correlation |
Revenue Per Gram is highly overall correlated with Gwt(Grams) and 4 other fields | High correlation |
Sales_Value is highly overall correlated with Gwt(Grams) and 4 other fields | High correlation |
Weight Max is highly overall correlated with Gwt(Grams) and 4 other fields | High correlation |
Weight Min is highly overall correlated with Gwt(Grams) and 4 other fields | High correlation |
Age has 219 (1.0%) zeros | Zeros |
Weight Min has 1221 (5.6%) zeros | Zeros |
Reproduction
| Analysis started | 2025-02-20 15:43:30.266923 |
|---|---|
| Analysis finished | 2025-02-20 15:43:48.583556 |
| Duration | 18.32 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
Branch
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.2 MiB |
| MDU | |
|---|---|
| CNI | |
| CBT | |
| SLM | 632 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CNI |
|---|---|
| 2nd row | CNI |
| 3rd row | CNI |
| 4th row | CNI |
| 5th row | MDU |
Common Values
| Value | Count | Frequency (%) |
| MDU | 9517 | |
| CNI | 7428 | |
| CBT | 4144 | |
| SLM | 632 | 2.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| mdu | 9517 | |
| cni | 7428 | |
| cbt | 4144 | |
| slm | 632 | 2.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 11572 | |
| M | 10149 | |
| D | 9517 | |
| U | 9517 | |
| N | 7428 | |
| I | 7428 | |
| B | 4144 | 6.4% |
| T | 4144 | 6.4% |
| S | 632 | 1.0% |
| L | 632 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 65163 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 11572 | |
| M | 10149 | |
| D | 9517 | |
| U | 9517 | |
| N | 7428 | |
| I | 7428 | |
| B | 4144 | 6.4% |
| T | 4144 | 6.4% |
| S | 632 | 1.0% |
| L | 632 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 65163 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 11572 | |
| M | 10149 | |
| D | 9517 | |
| U | 9517 | |
| N | 7428 | |
| I | 7428 | |
| B | 4144 | 6.4% |
| T | 4144 | 6.4% |
| S | 632 | 1.0% |
| L | 632 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 65163 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 11572 | |
| M | 10149 | |
| D | 9517 | |
| U | 9517 | |
| N | 7428 | |
| I | 7428 | |
| B | 4144 | 6.4% |
| T | 4144 | 6.4% |
| S | 632 | 1.0% |
| L | 632 | 1.0% |
Bill No
Text
| Distinct | 9358 |
|---|---|
| Distinct (%) | 43.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 3066 ? |
|---|---|
| Unique (%) | 14.1% |
Sample
| 1st row | GL-00153 |
|---|---|
| 2nd row | GL-00159 |
| 3rd row | GL-00216 |
| 4th row | GL-00237 |
| 5th row | GL-00417 |
| Value | Count | Frequency (%) |
| gl-04376 | 12 | 0.1% |
| gl-00201 | 12 | 0.1% |
| gl-01354 | 11 | 0.1% |
| gl-02093 | 11 | 0.1% |
| gl-05817 | 10 | < 0.1% |
| gl-00410 | 10 | < 0.1% |
| gl-00750 | 10 | < 0.1% |
| gl-00919 | 10 | < 0.1% |
| gl-00232 | 10 | < 0.1% |
| gl-00270 | 9 | < 0.1% |
| Other values (9348) | 21616 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 32086 | |
| G | 21721 | |
| L | 21721 | |
| - | 21721 | |
| 1 | 10331 | 5.9% |
| 2 | 9488 | 5.5% |
| 3 | 8935 | 5.1% |
| 7 | 8545 | 4.9% |
| 5 | 8406 | 4.8% |
| 6 | 8295 | 4.8% |
| Other values (3) | 22519 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 173768 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 32086 | |
| G | 21721 | |
| L | 21721 | |
| - | 21721 | |
| 1 | 10331 | 5.9% |
| 2 | 9488 | 5.5% |
| 3 | 8935 | 5.1% |
| 7 | 8545 | 4.9% |
| 5 | 8406 | 4.8% |
| 6 | 8295 | 4.8% |
| Other values (3) | 22519 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 173768 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 32086 | |
| G | 21721 | |
| L | 21721 | |
| - | 21721 | |
| 1 | 10331 | 5.9% |
| 2 | 9488 | 5.5% |
| 3 | 8935 | 5.1% |
| 7 | 8545 | 4.9% |
| 5 | 8406 | 4.8% |
| 6 | 8295 | 4.8% |
| Other values (3) | 22519 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 173768 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 32086 | |
| G | 21721 | |
| L | 21721 | |
| - | 21721 | |
| 1 | 10331 | 5.9% |
| 2 | 9488 | 5.5% |
| 3 | 8935 | 5.1% |
| 7 | 8545 | 4.9% |
| 5 | 8406 | 4.8% |
| 6 | 8295 | 4.8% |
| Other values (3) | 22519 |
Bill_date
Date
| Distinct | 334 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 169.8 KiB |
| Minimum | 2024-01-04 00:00:00 |
|---|---|
| Maximum | 2025-12-02 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Maker
Text
| Distinct | 106 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.2 MiB |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 2.6884582 |
| Min length | 1 |
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | J |
| Value | Count | Frequency (%) |
| a | 3589 | 16.5% |
| e | 1351 | 6.2% |
| d_28 | 1068 | 4.9% |
| y_23 | 964 | 4.4% |
| p_16 | 880 | 4.1% |
| j_58 | 830 | 3.8% |
| d | 789 | 3.6% |
| f | 724 | 3.3% |
| q | 558 | 2.6% |
| b | 510 | 2.3% |
| Other values (96) | 10458 |
Most occurring characters
| Value | Count | Frequency (%) |
| _ | 12257 | |
| A | 3786 | 6.5% |
| 2 | 3778 | 6.5% |
| 1 | 3581 | 6.1% |
| 3 | 3147 | 5.4% |
| 7 | 2942 | 5.0% |
| 8 | 2717 | 4.7% |
| 6 | 2210 | 3.8% |
| 4 | 2047 | 3.5% |
| 5 | 1935 | 3.3% |
| Other values (25) | 19996 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 58396 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| _ | 12257 | |
| A | 3786 | 6.5% |
| 2 | 3778 | 6.5% |
| 1 | 3581 | 6.1% |
| 3 | 3147 | 5.4% |
| 7 | 2942 | 5.0% |
| 8 | 2717 | 4.7% |
| 6 | 2210 | 3.8% |
| 4 | 2047 | 3.5% |
| 5 | 1935 | 3.3% |
| Other values (25) | 19996 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 58396 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| _ | 12257 | |
| A | 3786 | 6.5% |
| 2 | 3778 | 6.5% |
| 1 | 3581 | 6.1% |
| 3 | 3147 | 5.4% |
| 7 | 2942 | 5.0% |
| 8 | 2717 | 4.7% |
| 6 | 2210 | 3.8% |
| 4 | 2047 | 3.5% |
| 5 | 1935 | 3.3% |
| Other values (25) | 19996 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 58396 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| _ | 12257 | |
| A | 3786 | 6.5% |
| 2 | 3778 | 6.5% |
| 1 | 3581 | 6.1% |
| 3 | 3147 | 5.4% |
| 7 | 2942 | 5.0% |
| 8 | 2717 | 4.7% |
| 6 | 2210 | 3.8% |
| 4 | 2047 | 3.5% |
| 5 | 1935 | 3.3% |
| Other values (25) | 19996 |
Category
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 22KT |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 22KT |
|---|---|
| 2nd row | 22KT |
| 3rd row | 22KT |
| 4th row | 22KT |
| 5th row | 22KT |
Common Values
| Value | Count | Frequency (%) |
| 22KT | 21721 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 22kt | 21721 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 43442 | |
| K | 21721 | |
| T | 21721 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 86884 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 43442 | |
| K | 21721 | |
| T | 21721 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 86884 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 43442 | |
| K | 21721 | |
| T | 21721 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 86884 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 43442 | |
| K | 21721 | |
| T | 21721 |
Product
Categorical
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| GO_EARRINGS | |
|---|---|
| G CHAIN | |
| G RING | |
| GO_PENDANT | |
| LD BANGLES | |
| Other values (5) |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 8.9344413 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | G CHAIN |
|---|---|
| 2nd row | G CHAIN |
| 3rd row | G CHAIN |
| 4th row | G CHAIN |
| 5th row | G CHAIN |
Common Values
| Value | Count | Frequency (%) |
| GO_EARRINGS | 6202 | |
| G CHAIN | 4458 | |
| G RING | 4156 | |
| GO_PENDANT | 2227 | 10.3% |
| LD BANGLES | 1947 | 9.0% |
| GO_BRACELET | 1059 | 4.9% |
| GO_NECKLACE | 884 | 4.1% |
| GO_MALAI | 494 | 2.3% |
| GO_BESARI | 284 | 1.3% |
| GO_WATCH | 10 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| g | 8614 | |
| go_earrings | 6202 | |
| chain | 4458 | |
| ring | 4156 | |
| go_pendant | 2227 | 6.9% |
| ld | 1947 | 6.0% |
| bangles | 1947 | 6.0% |
| go_bracelet | 1059 | 3.3% |
| go_necklace | 884 | 2.7% |
| go_malai | 494 | 1.5% |
| Other values (2) | 294 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| G | 32079 | |
| N | 22101 | |
| A | 18059 | |
| R | 17903 | |
| I | 15594 | |
| E | 14546 | |
| O | 11160 | 5.8% |
| _ | 11160 | 5.8% |
| 10561 | 5.4% | |
| S | 8433 | 4.3% |
| Other values (10) | 32469 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 194065 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| G | 32079 | |
| N | 22101 | |
| A | 18059 | |
| R | 17903 | |
| I | 15594 | |
| E | 14546 | |
| O | 11160 | 5.8% |
| _ | 11160 | 5.8% |
| 10561 | 5.4% | |
| S | 8433 | 4.3% |
| Other values (10) | 32469 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 194065 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| G | 32079 | |
| N | 22101 | |
| A | 18059 | |
| R | 17903 | |
| I | 15594 | |
| E | 14546 | |
| O | 11160 | 5.8% |
| _ | 11160 | 5.8% |
| 10561 | 5.4% | |
| S | 8433 | 4.3% |
| Other values (10) | 32469 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 194065 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| G | 32079 | |
| N | 22101 | |
| A | 18059 | |
| R | 17903 | |
| I | 15594 | |
| E | 14546 | |
| O | 11160 | 5.8% |
| _ | 11160 | 5.8% |
| 10561 | 5.4% | |
| S | 8433 | 4.3% |
| Other values (10) | 32469 |
Design
Categorical
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| COIMBATORE | |
|---|---|
| CASTING | |
| BOMBAY | |
| HANDCRAFTED | |
| MACHINE MADE | |
| Other values (4) |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 8.7237696 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MACHINE MADE |
|---|---|
| 2nd row | MACHINE MADE |
| 3rd row | MACHINE MADE |
| 4th row | MACHINE MADE |
| 5th row | MACHINE MADE |
Common Values
| Value | Count | Frequency (%) |
| COIMBATORE | 5512 | |
| CASTING | 4501 | |
| BOMBAY | 2508 | |
| HANDCRAFTED | 2495 | |
| MACHINE MADE | 2147 | 9.9% |
| GEMSTONE | 1671 | 7.7% |
| KERALA | 1463 | 6.7% |
| EXCLUSIVE | 1067 | 4.9% |
| CALCUTTA | 357 | 1.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| coimbatore | 5512 | |
| casting | 4501 | |
| bombay | 2508 | |
| handcrafted | 2495 | |
| machine | 2147 | 9.0% |
| made | 2147 | 9.0% |
| gemstone | 1671 | 7.0% |
| kerala | 1463 | 6.1% |
| exclusive | 1067 | 4.5% |
| calcutta | 357 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 25445 | |
| E | 19240 | |
| C | 16436 | |
| O | 15203 | 8.0% |
| T | 14893 | 7.9% |
| M | 13985 | 7.4% |
| I | 13227 | 7.0% |
| N | 10814 | 5.7% |
| B | 10528 | 5.6% |
| R | 9470 | 5.0% |
| Other values (12) | 40248 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 189489 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 25445 | |
| E | 19240 | |
| C | 16436 | |
| O | 15203 | 8.0% |
| T | 14893 | 7.9% |
| M | 13985 | 7.4% |
| I | 13227 | 7.0% |
| N | 10814 | 5.7% |
| B | 10528 | 5.6% |
| R | 9470 | 5.0% |
| Other values (12) | 40248 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 189489 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 25445 | |
| E | 19240 | |
| C | 16436 | |
| O | 15203 | 8.0% |
| T | 14893 | 7.9% |
| M | 13985 | 7.4% |
| I | 13227 | 7.0% |
| N | 10814 | 5.7% |
| B | 10528 | 5.6% |
| R | 9470 | 5.0% |
| Other values (12) | 40248 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 189489 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 25445 | |
| E | 19240 | |
| C | 16436 | |
| O | 15203 | 8.0% |
| T | 14893 | 7.9% |
| M | 13985 | 7.4% |
| I | 13227 | 7.0% |
| N | 10814 | 5.7% |
| B | 10528 | 5.6% |
| R | 9470 | 5.0% |
| Other values (12) | 40248 |
Sub_Design
Text
| Distinct | 254 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
Length
| Max length | 8 |
|---|---|
| Median length | 5 |
| Mean length | 4.9000046 |
| Min length | 3 |
Unique
| Unique | 10 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | MC CH |
|---|---|
| 2nd row | 3 BAL KS |
| 3rd row | MC RO |
| 4th row | MC BO |
| 5th row | KO C |
| Value | Count | Frequency (%) |
| ca | 3950 | 9.8% |
| cbe | 3355 | 8.3% |
| r | 2977 | 7.4% |
| c | 1948 | 4.8% |
| by | 1919 | 4.8% |
| e | 1568 | 3.9% |
| er | 1188 | 3.0% |
| mc | 995 | 2.5% |
| d | 760 | 1.9% |
| bg | 734 | 1.8% |
| Other values (184) | 20859 |
Most occurring characters
| Value | Count | Frequency (%) |
| 18532 | ||
| C | 12507 | |
| A | 10897 | |
| B | 9529 | 9.0% |
| E | 8521 | 8.0% |
| R | 6153 | 5.8% |
| S | 4991 | 4.7% |
| L | 4171 | 3.9% |
| T | 4151 | 3.9% |
| M | 3108 | 2.9% |
| Other values (19) | 23873 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 106433 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 18532 | ||
| C | 12507 | |
| A | 10897 | |
| B | 9529 | 9.0% |
| E | 8521 | 8.0% |
| R | 6153 | 5.8% |
| S | 4991 | 4.7% |
| L | 4171 | 3.9% |
| T | 4151 | 3.9% |
| M | 3108 | 2.9% |
| Other values (19) | 23873 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 106433 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 18532 | ||
| C | 12507 | |
| A | 10897 | |
| B | 9529 | 9.0% |
| E | 8521 | 8.0% |
| R | 6153 | 5.8% |
| S | 4991 | 4.7% |
| L | 4171 | 3.9% |
| T | 4151 | 3.9% |
| M | 3108 | 2.9% |
| Other values (19) | 23873 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 106433 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 18532 | ||
| C | 12507 | |
| A | 10897 | |
| B | 9529 | 9.0% |
| E | 8521 | 8.0% |
| R | 6153 | 5.8% |
| S | 4991 | 4.7% |
| L | 4171 | 3.9% |
| T | 4151 | 3.9% |
| M | 3108 | 2.9% |
| Other values (19) | 23873 |
Pcs
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0290502 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 169.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.19720297 |
|---|---|
| Coefficient of variation (CV) | 0.1916359 |
| Kurtosis | 365.25495 |
| Mean | 1.0290502 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 12.889686 |
| Sum | 22352 |
| Variance | 0.03888901 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 1 | 21149 | |
| 2 | 533 | 2.5% |
| 3 | 31 | 0.1% |
| 4 | 5 | < 0.1% |
| 10 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 21149 | |
| 2 | 533 | 2.5% |
| 3 | 31 | 0.1% |
| 4 | 5 | < 0.1% |
| 5 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 10 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 4 | 5 | < 0.1% |
| 3 | 31 | 0.1% |
| 2 | 533 | 2.5% |
| 1 | 21149 |
Gwt(Grams)
Real number (ℝ)
High correlation
| Distinct | 3104 |
|---|---|
| Distinct (%) | 14.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.2344856 |
| Minimum | 0.1 |
|---|---|
| Maximum | 51.92 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 169.8 KiB |
Quantile statistics
| Minimum | 0.1 |
|---|---|
| 5-th percentile | 0.95 |
| Q1 | 2.55 |
| median | 4.71 |
| Q3 | 12.17 |
| 95-th percentile | 32.05 |
| Maximum | 51.92 |
| Range | 51.82 |
| Interquartile range (IQR) | 9.62 |
Descriptive statistics
| Standard deviation | 9.8051314 |
|---|---|
| Coefficient of variation (CV) | 1.0617951 |
| Kurtosis | 2.4754746 |
| Mean | 9.2344856 |
| Median Absolute Deviation (MAD) | 3.31 |
| Skewness | 1.7097499 |
| Sum | 200582.26 |
| Variance | 96.140601 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4 | 153 | 0.7% |
| 4.05 | 134 | 0.6% |
| 4.06 | 129 | 0.6% |
| 1.02 | 125 | 0.6% |
| 2 | 122 | 0.6% |
| 4.08 | 120 | 0.6% |
| 2.05 | 120 | 0.6% |
| 4.04 | 113 | 0.5% |
| 4.1 | 110 | 0.5% |
| 4.03 | 108 | 0.5% |
| Other values (3094) | 20487 |
| Value | Count | Frequency (%) |
| 0.1 | 1 | < 0.1% |
| 0.11 | 1 | < 0.1% |
| 0.12 | 9 | < 0.1% |
| 0.13 | 10 | < 0.1% |
| 0.14 | 26 | |
| 0.15 | 26 | |
| 0.16 | 52 | |
| 0.17 | 13 | 0.1% |
| 0.18 | 6 | < 0.1% |
| 0.19 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 51.92 | 1 | |
| 51.73 | 1 | |
| 51.67 | 1 | |
| 50.87 | 2 | |
| 50.36 | 1 | |
| 50.13 | 1 | |
| 50 | 1 | |
| 49.35 | 1 | |
| 49.26 | 1 | |
| 49.07 | 1 |
Sales_Value
Real number (ℝ)
High correlation
| Distinct | 20943 |
|---|---|
| Distinct (%) | 96.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54194.255 |
| Minimum | 3749.99 |
|---|---|
| Maximum | 286590.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 169.8 KiB |
Quantile statistics
| Minimum | 3749.99 |
|---|---|
| 5-th percentile | 8992.36 |
| Q1 | 18235.7 |
| median | 30528.09 |
| Q3 | 71279.46 |
| 95-th percentile | 174750.34 |
| Maximum | 286590.5 |
| Range | 282840.51 |
| Interquartile range (IQR) | 53043.76 |
Descriptive statistics
| Standard deviation | 52873.527 |
|---|---|
| Coefficient of variation (CV) | 0.97562974 |
| Kurtosis | 2.5382574 |
| Mean | 54194.255 |
| Median Absolute Deviation (MAD) | 17320.58 |
| Skewness | 1.7134048 |
| Sum | 1.1771534 × 109 |
| Variance | 2.7956098 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25749.9 | 7 | < 0.1% |
| 25749.67 | 5 | < 0.1% |
| 46750.28 | 5 | < 0.1% |
| 14750.46 | 4 | < 0.1% |
| 26750.45 | 4 | < 0.1% |
| 14950.36 | 4 | < 0.1% |
| 46750.08 | 4 | < 0.1% |
| 15250.43 | 4 | < 0.1% |
| 25749.7 | 4 | < 0.1% |
| 25749.62 | 4 | < 0.1% |
| Other values (20933) | 21676 |
| Value | Count | Frequency (%) |
| 3749.99 | 1 | |
| 3750 | 1 | |
| 4449.63 | 1 | |
| 4455 | 1 | |
| 4500.09 | 1 | |
| 4500.2 | 1 | |
| 4500.38 | 1 | |
| 4501.79 | 1 | |
| 4502.61 | 1 | |
| 4509.14 | 1 |
| Value | Count | Frequency (%) |
| 286590.5 | 1 | |
| 284402.11 | 1 | |
| 284090.15 | 1 | |
| 281250.32 | 1 | |
| 281249.8 | 1 | |
| 280949.89 | 1 | |
| 280749.95 | 1 | |
| 279833.55 | 1 | |
| 279329.66 | 1 | |
| 278596.46 | 1 |
Age
Real number (ℝ)
Zeros
| Distinct | 1560 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 193.38437 |
| Minimum | -133 |
|---|---|
| Maximum | 19390 |
| Zeros | 219 |
| Zeros (%) | 1.0% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 169.8 KiB |
Quantile statistics
| Minimum | -133 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 29 |
| median | 73 |
| Q3 | 172 |
| 95-th percentile | 817 |
| Maximum | 19390 |
| Range | 19523 |
| Interquartile range (IQR) | 143 |
Descriptive statistics
| Standard deviation | 461.85472 |
|---|---|
| Coefficient of variation (CV) | 2.3882732 |
| Kurtosis | 548.06307 |
| Mean | 193.38437 |
| Median Absolute Deviation (MAD) | 55 |
| Skewness | 15.696018 |
| Sum | 4200502 |
| Variance | 213309.78 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 282 | 1.3% |
| 2 | 258 | 1.2% |
| 3 | 239 | 1.1% |
| 4 | 237 | 1.1% |
| 5 | 232 | 1.1% |
| 0 | 219 | 1.0% |
| 6 | 215 | 1.0% |
| 7 | 203 | 0.9% |
| 10 | 186 | 0.9% |
| 16 | 181 | 0.8% |
| Other values (1550) | 19469 |
| Value | Count | Frequency (%) |
| -133 | 1 | < 0.1% |
| 0 | 219 | |
| 1 | 282 | |
| 2 | 258 | |
| 3 | 239 | |
| 4 | 237 | |
| 5 | 232 | |
| 6 | 215 | |
| 7 | 203 | |
| 8 | 176 |
| Value | Count | Frequency (%) |
| 19390 | 1 | |
| 19330 | 1 | |
| 19199 | 1 | |
| 19147 | 1 | |
| 3870 | 2 | |
| 3869 | 1 | |
| 3865 | 1 | |
| 3849 | 1 | |
| 3831 | 1 | |
| 3827 | 1 |
Employee
Text
| Distinct | 97 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 15 |
| Mean length | 9.6061876 |
| Min length | 4 |
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | RAJAPRIYA |
|---|---|
| 2nd row | MUTHUMATHI |
| 3rd row | ARUNACHALAM |
| 4th row | MANIKANDAN |
| 5th row | SELVAM |
| Value | Count | Frequency (%) |
| kumar | 2146 | 8.0% |
| ravikumar | 1552 | 5.8% |
| manoj | 1018 | 3.8% |
| arun | 980 | 3.7% |
| rajaprabhu | 893 | 3.3% |
| ramamoorthy | 856 | 3.2% |
| raguram | 763 | 2.8% |
| kamatchi | 757 | 2.8% |
| elackiya | 754 | 2.8% |
| muthu | 697 | 2.6% |
| Other values (103) | 16427 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 47609 | |
| R | 18345 | 8.8% |
| M | 17683 | 8.5% |
| N | 14520 | 7.0% |
| U | 13068 | 6.3% |
| H | 12440 | 6.0% |
| I | 12063 | 5.8% |
| K | 11391 | 5.5% |
| T | 7622 | 3.7% |
| S | 6111 | 2.9% |
| Other values (17) | 47804 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 208656 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 47609 | |
| R | 18345 | 8.8% |
| M | 17683 | 8.5% |
| N | 14520 | 7.0% |
| U | 13068 | 6.3% |
| H | 12440 | 6.0% |
| I | 12063 | 5.8% |
| K | 11391 | 5.5% |
| T | 7622 | 3.7% |
| S | 6111 | 2.9% |
| Other values (17) | 47804 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 208656 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 47609 | |
| R | 18345 | 8.8% |
| M | 17683 | 8.5% |
| N | 14520 | 7.0% |
| U | 13068 | 6.3% |
| H | 12440 | 6.0% |
| I | 12063 | 5.8% |
| K | 11391 | 5.5% |
| T | 7622 | 3.7% |
| S | 6111 | 2.9% |
| Other values (17) | 47804 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 208656 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 47609 | |
| R | 18345 | 8.8% |
| M | 17683 | 8.5% |
| N | 14520 | 7.0% |
| U | 13068 | 6.3% |
| H | 12440 | 6.0% |
| I | 12063 | 5.8% |
| K | 11391 | 5.5% |
| T | 7622 | 3.7% |
| S | 6111 | 2.9% |
| Other values (17) | 47804 |
Purchase Value
Real number (ℝ)
High correlation
| Distinct | 13099 |
|---|---|
| Distinct (%) | 60.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 39016.188 |
| Minimum | 3750 |
|---|---|
| Maximum | 238968.79 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 169.8 KiB |
Quantile statistics
| Minimum | 3750 |
|---|---|
| 5-th percentile | 3750 |
| Q1 | 4459.92 |
| median | 20432 |
| Q3 | 49722 |
| 95-th percentile | 149419 |
| Maximum | 238968.79 |
| Range | 235218.79 |
| Interquartile range (IQR) | 45262.08 |
Descriptive statistics
| Standard deviation | 47282.584 |
|---|---|
| Coefficient of variation (CV) | 1.211871 |
| Kurtosis | 3.2185868 |
| Mean | 39016.188 |
| Median Absolute Deviation (MAD) | 16682 |
| Skewness | 1.8847459 |
| Sum | 8.4747061 × 108 |
| Variance | 2.2356428 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3750 | 5383 | 24.8% |
| 4586.5 | 40 | 0.2% |
| 6419.09 | 18 | 0.1% |
| 24261.45 | 16 | 0.1% |
| 4491 | 16 | 0.1% |
| 8868.69 | 14 | 0.1% |
| 5723 | 14 | 0.1% |
| 6702.88 | 12 | 0.1% |
| 5675 | 11 | 0.1% |
| 14021.4 | 11 | 0.1% |
| Other values (13089) | 16186 |
| Value | Count | Frequency (%) |
| 3750 | 5383 | |
| 3762.24 | 1 | < 0.1% |
| 4166.36 | 1 | < 0.1% |
| 4193.39 | 1 | < 0.1% |
| 4203.03 | 1 | < 0.1% |
| 4206.8 | 2 | < 0.1% |
| 4208.89 | 1 | < 0.1% |
| 4212.66 | 2 | < 0.1% |
| 4218.53 | 1 | < 0.1% |
| 4317.63 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 238968.79 | 1 | |
| 238685.4 | 1 | |
| 238235.68 | 1 | |
| 238163.34 | 1 | |
| 238109.11 | 1 | |
| 237981.84 | 1 | |
| 237475 | 1 | |
| 237235.2 | 1 | |
| 236236 | 1 | |
| 235802.51 | 1 |
Weight Min
Real number (ℝ)
High correlation Zeros
| Distinct | 29 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.6679711 |
| Minimum | 0 |
|---|---|
| Maximum | 52 |
| Zeros | 1221 |
| Zeros (%) | 5.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 169.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 5 |
| Q3 | 10 |
| 95-th percentile | 28 |
| Maximum | 52 |
| Range | 52 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 8.4512384 |
|---|---|
| Coefficient of variation (CV) | 1.1021479 |
| Kurtosis | 3.4666872 |
| Mean | 7.6679711 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 1.9083887 |
| Sum | 166556 |
| Variance | 71.42343 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=29)
| Value | Count | Frequency (%) |
| 5 | 3931 | |
| 3 | 2724 | |
| 1 | 2138 | |
| 2 | 1923 | |
| 6 | 1393 | 6.4% |
| 0 | 1221 | 5.6% |
| 20 | 1052 | 4.8% |
| 10 | 1011 | 4.7% |
| 4 | 960 | 4.4% |
| 14 | 807 | 3.7% |
| Other values (19) | 4561 |
| Value | Count | Frequency (%) |
| 0 | 1221 | 5.6% |
| 0.5 | 474 | 2.2% |
| 1 | 2138 | |
| 2 | 1923 | |
| 3 | 2724 | |
| 4 | 960 | 4.4% |
| 5 | 3931 | |
| 6 | 1393 | 6.4% |
| 7 | 390 | 1.8% |
| 8 | 680 | 3.1% |
| Value | Count | Frequency (%) |
| 52 | 1 | < 0.1% |
| 48 | 9 | < 0.1% |
| 44 | 35 | 0.2% |
| 42 | 1 | < 0.1% |
| 40 | 149 | |
| 36 | 352 | |
| 34 | 2 | < 0.1% |
| 32 | 310 | |
| 28 | 316 | |
| 26 | 1 | < 0.1% |
Weight Max
Real number (ℝ)
High correlation
| Distinct | 32 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.559988 |
| Minimum | 0.5 |
|---|---|
| Maximum | 56 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 169.8 KiB |
Quantile statistics
| Minimum | 0.5 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 12 |
| 95-th percentile | 32 |
| Maximum | 56 |
| Range | 55.5 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 9.8351533 |
|---|---|
| Coefficient of variation (CV) | 1.028783 |
| Kurtosis | 3.1251186 |
| Mean | 9.559988 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 1.8730735 |
| Sum | 207652.5 |
| Variance | 96.730241 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=32)
| Value | Count | Frequency (%) |
| 6 | 4499 | |
| 4 | 2949 | |
| 2 | 2114 | |
| 3 | 1698 | 7.8% |
| 8 | 1676 | 7.7% |
| 1 | 1431 | 6.6% |
| 16 | 1310 | 6.0% |
| 24 | 1017 | 4.7% |
| 12 | 1011 | 4.7% |
| 32 | 681 | 3.1% |
| Other values (22) | 3335 |
| Value | Count | Frequency (%) |
| 0.5 | 228 | 1.0% |
| 1 | 1431 | 6.6% |
| 1.5 | 25 | 0.1% |
| 2 | 2114 | |
| 3 | 1698 | 7.8% |
| 4 | 2949 | |
| 5 | 392 | 1.8% |
| 6 | 4499 | |
| 7 | 134 | 0.6% |
| 8 | 1676 | 7.7% |
| Value | Count | Frequency (%) |
| 56 | 6 | < 0.1% |
| 52 | 4 | < 0.1% |
| 50 | 1 | < 0.1% |
| 48 | 157 | 0.7% |
| 44 | 27 | 0.1% |
| 42 | 2 | < 0.1% |
| 40 | 628 | |
| 36 | 34 | 0.2% |
| 34 | 1 | < 0.1% |
| 32 | 681 |
Profit Margin %
Real number (ℝ)
High correlation
| Distinct | 21638 |
|---|---|
| Distinct (%) | 99.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.776264 |
| Minimum | -1157.9897 |
|---|---|
| Maximum | 98.691513 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 1260 |
| Negative (%) | 5.8% |
| Memory size | 169.8 KiB |
Quantile statistics
| Minimum | -1157.9897 |
|---|---|
| 5-th percentile | -0.60906152 |
| Q1 | 5.2410775 |
| median | 9.8295583 |
| Q3 | 43.604867 |
| 95-th percentile | 95.058039 |
| Maximum | 98.691513 |
| Range | 1256.6812 |
| Interquartile range (IQR) | 38.36379 |
Descriptive statistics
| Standard deviation | 37.224538 |
|---|---|
| Coefficient of variation (CV) | 1.3902066 |
| Kurtosis | 63.645348 |
| Mean | 26.776264 |
| Median Absolute Deviation (MAD) | 5.8411007 |
| Skewness | -1.6744666 |
| Sum | 581607.23 |
| Variance | 1385.6663 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 94.40993594 | 4 | < 0.1% |
| 85.32265501 | 4 | < 0.1% |
| 85.43683665 | 3 | < 0.1% |
| 85.43700066 | 3 | < 0.1% |
| 85.43667829 | 3 | < 0.1% |
| 5.996752663 | 3 | < 0.1% |
| 6.454231499 | 2 | < 0.1% |
| 74.57558171 | 2 | < 0.1% |
| 85.14826193 | 2 | < 0.1% |
| 85.08956401 | 2 | < 0.1% |
| Other values (21628) | 21693 |
| Value | Count | Frequency (%) |
| -1157.989723 | 1 | |
| -745.832046 | 1 | |
| -554.8766277 | 1 | |
| -532.8610756 | 1 | |
| -507.0125307 | 1 | |
| -383.651017 | 1 | |
| -300.2868052 | 1 | |
| -283.466067 | 1 | |
| -249.9737615 | 1 | |
| -245.1506633 | 1 |
| Value | Count | Frequency (%) |
| 98.6915128 | 1 | |
| 98.67999647 | 1 | |
| 98.66666818 | 1 | |
| 98.6652424 | 1 | |
| 98.65991765 | 1 | |
| 98.65750025 | 1 | |
| 98.65112737 | 1 | |
| 98.64750632 | 1 | |
| 98.64514546 | 1 | |
| 98.63097231 | 1 |
Revenue Per Gram
Real number (ℝ)
High correlation
| Distinct | 21652 |
|---|---|
| Distinct (%) | 99.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6972.6807 |
| Minimum | 221.23835 |
|---|---|
| Maximum | 55113.154 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 169.8 KiB |
Quantile statistics
| Minimum | 221.23835 |
|---|---|
| 5-th percentile | 5293.1484 |
| Q1 | 5757.0131 |
| median | 6352.2983 |
| Q3 | 7183.6082 |
| 95-th percentile | 9973.7347 |
| Maximum | 55113.154 |
| Range | 54891.916 |
| Interquartile range (IQR) | 1426.5952 |
Descriptive statistics
| Standard deviation | 2804.9379 |
|---|---|
| Coefficient of variation (CV) | 0.40227539 |
| Kurtosis | 52.88802 |
| Mean | 6972.6807 |
| Median Absolute Deviation (MAD) | 671.0789 |
| Skewness | 6.2635195 |
| Sum | 1.514536 × 108 |
| Variance | 7867676.4 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5646.743266 | 4 | < 0.1% |
| 6373.641089 | 3 | < 0.1% |
| 5446.866145 | 3 | < 0.1% |
| 5634.470076 | 2 | < 0.1% |
| 6589.864078 | 2 | < 0.1% |
| 9132.981818 | 2 | < 0.1% |
| 7374.745 | 2 | < 0.1% |
| 9559.127451 | 2 | < 0.1% |
| 7258.009217 | 2 | < 0.1% |
| 7449.40404 | 2 | < 0.1% |
| Other values (21642) | 21697 |
| Value | Count | Frequency (%) |
| 221.2383481 | 1 | |
| 789.4736842 | 1 | |
| 1388.770916 | 1 | |
| 2042.361416 | 1 | |
| 2978.620227 | 1 | |
| 3504.152581 | 1 | |
| 3566.657089 | 1 | |
| 3621.660759 | 1 | |
| 3708.70697 | 1 | |
| 3710.273115 | 1 |
| Value | Count | Frequency (%) |
| 55113.15385 | 1 | |
| 47159.6 | 1 | |
| 45824.25 | 1 | |
| 40451.18182 | 1 | |
| 40049.66667 | 1 | |
| 38335.33333 | 1 | |
| 37917.58333 | 1 | |
| 37576.16667 | 1 | |
| 37521.75 | 1 | |
| 37514.91667 | 1 |
Product Performance
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Slow Moving | |
|---|---|
| Fast Moving |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Slow Moving |
|---|---|
| 2nd row | Fast Moving |
| 3rd row | Fast Moving |
| 4th row | Fast Moving |
| 5th row | Fast Moving |
Common Values
| Value | Count | Frequency (%) |
| Slow Moving | 16084 | |
| Fast Moving | 5637 | 26.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| moving | 21721 | |
| slow | 16084 | |
| fast | 5637 | 13.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 37805 | |
| 21721 | ||
| M | 21721 | |
| v | 21721 | |
| i | 21721 | |
| n | 21721 | |
| g | 21721 | |
| S | 16084 | |
| l | 16084 | |
| w | 16084 | |
| Other values (4) | 22548 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 238931 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 37805 | |
| 21721 | ||
| M | 21721 | |
| v | 21721 | |
| i | 21721 | |
| n | 21721 | |
| g | 21721 | |
| S | 16084 | |
| l | 16084 | |
| w | 16084 | |
| Other values (4) | 22548 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 238931 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 37805 | |
| 21721 | ||
| M | 21721 | |
| v | 21721 | |
| i | 21721 | |
| n | 21721 | |
| g | 21721 | |
| S | 16084 | |
| l | 16084 | |
| w | 16084 | |
| Other values (4) | 22548 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 238931 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 37805 | |
| 21721 | ||
| M | 21721 | |
| v | 21721 | |
| i | 21721 | |
| n | 21721 | |
| g | 21721 | |
| S | 16084 | |
| l | 16084 | |
| w | 16084 | |
| Other values (4) | 22548 |
Interactions
Correlations
| Age | Branch | Design | Gwt(Grams) | Pcs | Product | Product Performance | Profit Margin % | Purchase Value | Revenue Per Gram | Sales_Value | Weight Max | Weight Min | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Age | 1.000 | 0.050 | 0.066 | -0.065 | 0.068 | 0.047 | 0.068 | 0.294 | -0.196 | 0.069 | -0.062 | -0.021 | -0.016 |
| Branch | 0.050 | 1.000 | 0.108 | 0.066 | 0.002 | 0.086 | 0.150 | 0.000 | 0.056 | 0.063 | 0.069 | 0.052 | 0.049 |
| Design | 0.066 | 0.108 | 1.000 | 0.182 | 0.073 | 0.362 | 0.098 | 0.013 | 0.172 | 0.185 | 0.172 | 0.180 | 0.187 |
| Gwt(Grams) | -0.065 | 0.066 | 0.182 | 1.000 | 0.030 | 0.324 | 0.073 | 0.076 | 0.583 | -0.901 | 0.996 | 0.888 | 0.878 |
| Pcs | 0.068 | 0.002 | 0.073 | 0.030 | 1.000 | 0.129 | 0.031 | 0.003 | 0.030 | -0.004 | 0.032 | 0.040 | 0.039 |
| Product | 0.047 | 0.086 | 0.362 | 0.324 | 0.129 | 1.000 | 0.118 | 0.021 | 0.282 | 0.352 | 0.308 | 0.325 | 0.334 |
| Product Performance | 0.068 | 0.150 | 0.098 | 0.073 | 0.031 | 0.118 | 1.000 | 0.000 | 0.110 | 0.058 | 0.070 | 0.062 | 0.057 |
| Profit Margin % | 0.294 | 0.000 | 0.013 | 0.076 | 0.003 | 0.021 | 0.000 | 1.000 | -0.565 | 0.069 | 0.103 | 0.046 | 0.046 |
| Purchase Value | -0.196 | 0.056 | 0.172 | 0.583 | 0.030 | 0.282 | 0.110 | -0.565 | 1.000 | -0.511 | 0.584 | 0.525 | 0.520 |
| Revenue Per Gram | 0.069 | 0.063 | 0.185 | -0.901 | -0.004 | 0.352 | 0.058 | 0.069 | -0.511 | 1.000 | -0.869 | -0.796 | -0.786 |
| Sales_Value | -0.062 | 0.069 | 0.172 | 0.996 | 0.032 | 0.308 | 0.070 | 0.103 | 0.584 | -0.869 | 1.000 | 0.886 | 0.876 |
| Weight Max | -0.021 | 0.052 | 0.180 | 0.888 | 0.040 | 0.325 | 0.062 | 0.046 | 0.525 | -0.796 | 0.886 | 1.000 | 0.993 |
| Weight Min | -0.016 | 0.049 | 0.187 | 0.878 | 0.039 | 0.334 | 0.057 | 0.046 | 0.520 | -0.786 | 0.876 | 0.993 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| Branch | Bill No | Bill_date | Maker | Category | Product | Design | Sub_Design | Pcs | Gwt(Grams) | Sales_Value | Age | Employee | Purchase Value | Weight Min | Weight Max | Profit Margin % | Revenue Per Gram | Product Performance | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | CNI | GL-00153 | 08/04/2024 | A | 22KT | G CHAIN | MACHINE MADE | MC CH | 1 | 4.05 | 25049.86 | 216 | RAJAPRIYA | 22553.00 | 2.0 | 4.0 | 9.967561 | 6185.150617 | Slow Moving |
| 1 | CNI | GL-00159 | 08/04/2024 | A | 22KT | G CHAIN | MACHINE MADE | 3 BAL KS | 1 | 40.58 | 218750.04 | 7 | MUTHUMATHI | 205343.43 | 36.0 | 40.0 | 6.128735 | 5390.587482 | Fast Moving |
| 2 | CNI | GL-00216 | 10/04/2024 | A | 22KT | G CHAIN | MACHINE MADE | MC RO | 1 | 12.03 | 68750.20 | 10 | ARUNACHALAM | 3750.00 | 10.0 | 12.0 | 94.545470 | 5714.896093 | Fast Moving |
| 3 | CNI | GL-00237 | 11/04/2024 | A | 22KT | G CHAIN | MACHINE MADE | MC BO | 1 | 23.94 | 129720.63 | 14 | MANIKANDAN | 124371.44 | 20.0 | 24.0 | 4.123623 | 5418.572682 | Fast Moving |
| 4 | MDU | GL-00417 | 14/04/2024 | J | 22KT | G CHAIN | MACHINE MADE | KO C | 1 | 39.44 | 229750.43 | 0 | SELVAM | 207175.04 | 36.0 | 40.0 | 9.826049 | 5825.315162 | Fast Moving |
| 5 | MDU | GL-00422 | 14/04/2024 | A | 22KT | G CHAIN | MACHINE MADE | MC KA | 1 | 8.52 | 54454.06 | 17 | RAVIKUMAR | 46222.64 | 6.0 | 8.0 | 15.116265 | 6391.321596 | Fast Moving |
| 6 | CNI | GL-00349 | 18/04/2024 | A | 22KT | G CHAIN | MACHINE MADE | 3 BAL K | 1 | 24.15 | 133750.42 | 17 | PRAKASH | 123722.06 | 20.0 | 24.0 | 7.497816 | 5538.319669 | Fast Moving |
| 7 | CNI | GL-00460 | 25/04/2024 | A | 22KT | G CHAIN | MACHINE MADE | MC RO | 1 | 8.00 | 47112.55 | 25 | RAVIKUMAR | 3750.00 | 6.0 | 8.0 | 92.040337 | 5889.068750 | Fast Moving |
| 8 | CNI | GL-00481 | 27/04/2024 | D | 22KT | G CHAIN | MACHINE MADE | MC CH | 1 | 9.63 | 55460.77 | 179 | VENKATESH | 49558.00 | 8.0 | 10.0 | 10.643145 | 5759.166147 | Slow Moving |
| 9 | CNI | GL-00496 | 27/04/2024 | A | 22KT | G CHAIN | MACHINE MADE | MC DE | 1 | 16.17 | 89638.08 | 369 | RAJAPRIYA | 79053.00 | 14.0 | 16.0 | 11.808687 | 5543.480519 | Slow Moving |
| Branch | Bill No | Bill_date | Maker | Category | Product | Design | Sub_Design | Pcs | Gwt(Grams) | Sales_Value | Age | Employee | Purchase Value | Weight Min | Weight Max | Profit Margin % | Revenue Per Gram | Product Performance | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21711 | SLM | GL-00432 | 01/02/2025 | P_16 | 22KT | GO_MALAI | COIMBATORE | VA MA | 1 | 21.49 | 135240.39 | 56 | VANI PRABHA | 117098.53 | 16.0 | 20.0 | 13.414528 | 6293.177757 | Slow Moving |
| 21712 | SLM | GL-00446 | 04/02/2025 | P_16 | 22KT | GO_MALAI | COIMBATORE | VA MA | 1 | 21.38 | 132814.63 | 59 | VANI PRABHA | 116518.61 | 16.0 | 20.0 | 12.269748 | 6212.096819 | Slow Moving |
| 21713 | MDU | GL-10898 | 25/02/2025 | P_16 | 22KT | GO_MALAI | COIMBATORE | VA MA | 1 | 37.40 | 223994.51 | 80 | RAGURAM | 201014.99 | 32.0 | 40.0 | 10.258966 | 5989.158021 | Slow Moving |
| 21714 | CNI | GL-08133 | 10/02/2025 | J_58 | 22KT | GO_MALAI | COIMBATORE | KA MAA | 1 | 30.12 | 183751.38 | 202 | RAMANATHAN | 155610.26 | 24.0 | 32.0 | 15.314780 | 6100.643426 | Slow Moving |
| 21715 | CNI | GL-07980 | 02/02/2025 | Y_23 | 22KT | GO_MALAI | COIMBATORE | LA MAA | 1 | 32.92 | 202399.82 | 95 | PRABU KUMAR | 166801.20 | 24.0 | 32.0 | 17.588267 | 6148.232685 | Slow Moving |
| 21716 | CNI | GL-08077 | 06/02/2025 | M_85 | 22KT | GO_MALAI | COIMBATORE | LA MAA | 1 | 30.52 | 200558.44 | 58 | KAMATCHI | 164671.46 | 24.0 | 32.0 | 17.893528 | 6571.377457 | Slow Moving |
| 21717 | CBT | GL-03984 | 06/02/2025 | T_91 | 22KT | GO_MALAI | COIMBATORE | LA MAA | 1 | 42.60 | 255595.31 | 146 | RAVIKUMAR | 217655.93 | 32.0 | 40.0 | 14.843535 | 5999.889906 | Slow Moving |
| 21718 | CNI | GL-08082 | 06/02/2025 | M_85 | 22KT | GO_MALAI | COIMBATORE | LA MAA | 1 | 38.08 | 229450.43 | 58 | PRABU KUMAR | 204527.78 | 32.0 | 40.0 | 10.861889 | 6025.483981 | Slow Moving |
| 21719 | CNI | GL-08113 | 08/02/2025 | P_16 | 22KT | GO_MALAI | COIMBATORE | LA MAA | 1 | 22.28 | 137750.50 | 112 | KAMATCHI | 113879.75 | 20.0 | 24.0 | 17.328975 | 6182.697487 | Slow Moving |
| 21720 | MDU | GL-10645 | 15/02/2025 | T_91 | 22KT | GO_MALAI | COIMBATORE | LA MAA | 1 | 35.18 | 224948.35 | 155 | KAVITHA | 180398.66 | 32.0 | 40.0 | 19.804408 | 6394.211200 | Slow Moving |